import pandas as pd

df = pd.read_excel("house.xlsx",sheet_name="Sheet1")

df["unit_price"] = df["unit_price"].map(lambda x:x.replace(",","").replace("元/平",""))
df["unit_price"] = df["unit_price"].astype("int")
print(df["unit_price"].mean())


